<?php

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */

/**
 * Description of EmpleadoDB
 *
 * @author Admin
 */
class Consulta3DB extends CI_Model {

    var $title = '';
    var $content = '';
    var $date = '';

    function __construct() {
        // Call the Model constructor
        parent::__construct();
    }

    function Consulta3($arrData) {       
               
        $query = $this->db
                ->select("cod_b,cod_s")
                ->from("sucursal")                
                ->where("cod_b",$arrData['cod_b'])
                ->get();
        
        
        return $query->result(); 
        
       // select table_name from INFORMATION_SCHEMA.views;
        
        
       /* SELECT Cod_B, Cod_S
                    FROM sucursal
                    WHERE Cod_B=banco;*/
    }
    
    function Consulta3_1($arrData){
                    
            //$query1 = $this->db->
                            
            return $query1->result();                
    }
}  